<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Spring boot Mybatis | analysis</title>
<!-- Tell the browser to be responsive to screen width -->
<meta
	content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"
	name="viewport">
<!-- Bootstrap 3.3.7 -->
<link rel="stylesheet"
	href="bower_components/bootstrap/dist/css/bootstrap.min.css">
<!-- Font Awesome -->
<link rel="stylesheet"
	href="bower_components/font-awesome/css/font-awesome.min.css">
<!-- Ionicons -->
<link rel="stylesheet"
	href="bower_components/Ionicons/css/ionicons.min.css">
<!-- jvectormap -->
<link rel="stylesheet"
	href="bower_components/jvectormap/jquery-jvectormap.css">
<!-- bootgrid -->
<link rel="stylesheet" href="dist/css/jquery.bootgrid.min.css" />
<!-- bootstrap datepicker -->
<link rel="stylesheet"
	href="bower_components/bootstrap-datepicker/dist/css/bootstrap-datepicker.min.css">
<!-- Theme style -->
<link rel="stylesheet" href="dist/css/AdminLTE.min.css">
<!-- AdminLTE Skins. Choose a skin from the css/skins
       folder instead of downloading all of them to reduce the load. -->
<link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">

<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  <![endif]-->

<!-- Google Font -->
<link rel="stylesheet" href="dist/css/fonts.googleapis.com.css">
</head>
<body class="hold-transition skin-blue sidebar-mini fixed">
	<div class="wrapper">

		<header class="main-header">

			<!-- Logo -->
			<a href="index2.html" class="logo"> <!-- mini logo for sidebar mini 50x50 pixels -->
				<span class="logo-mini"><b>A</b>LT</span> <!-- logo for regular state and mobile devices -->
				<span class="logo-lg"><b>Spring boot </b>Mybatis</span>
			</a>

			<!-- Header Navbar: style can be found in header.less -->
			<nav class="navbar navbar-static-top">
				<!-- Sidebar toggle button-->
				<a href="#" class="sidebar-toggle" data-toggle="push-menu"
					role="button"> <span class="sr-only">Toggle navigation</span>
				</a>
				<!-- Navbar Right Menu -->
				<div class="navbar-custom-menu">
					<ul class="nav navbar-nav">


						<!-- User Account: style can be found in dropdown.less -->
						<li class="dropdown user user-menu"><a href="#"
							class="dropdown-toggle" data-toggle="dropdown"> <img
								src="dist/img/user2-160x160.jpg" class="user-image"
								alt="User Image"> <span class="hidden-xs username">
							</span>
						</a>
							<ul class="dropdown-menu">
								<!-- User image -->
								<li class="user-header"><img
									src="dist/img/user2-160x160.jpg" class="img-circle"
									alt="User Image">

									<p>
										Alexander Pierce - Web Developer <small>Member since
											Nov. 2012</small>
									</p></li></li>
						<!-- Menu Footer-->
						<li class="user-footer">

							<div class="pull-right">
								<a href="logout" class="btn btn-default btn-flat">Sign out</a>
							</div>
						</li>
					</ul>
					</li>
					<!-- Control Sidebar Toggle Button -->
					<li><a href="#" data-toggle="control-sidebar"><i
							class="fa fa-gears"></i></a></li>
					</ul>
				</div>

			</nav>
		</header>
		<!-- Left side column. contains the logo and sidebar -->
		<aside class="main-sidebar">
			<!-- sidebar: style can be found in sidebar.less -->
			<section class="sidebar">
				<!-- Sidebar user panel -->
				<div class="user-panel">
					<div class="pull-left image">
						<img src="dist/img/user2-160x160.jpg" class="img-circle"
							alt="User Image">
					</div>
					<div class="pull-left info">
						<p class="username">Alexander Pierce</p>
						<a href="#"><i class="fa fa-circle text-success"></i> Online</a>
					</div>
				</div>

				<!-- sidebar menu: : style can be found in sidebar.less -->
				<ul class="sidebar-menu" data-widget="tree">
					<li class="header">MAIN NAVIGATION</li>
					<li class="treeview"><a href="#"> <i
							class="fa fa-dashboard"></i> <span>演员表</span> <span
							class="pull-right-container"> <i
								class="fa fa-angle-left pull-right"></i>
						</span>
					</a>
						<ul class="treeview-menu">
							<li><a href="showactor"><i class="fa fa-circle-o"></i>
									actors</a></li>
						</ul></li>
					<li class="treeview"><a href="#"> <i class="fa fa-edit"></i> <span>国家与城市表</span>
							<span class="pull-right-container"> <i
								class="fa fa-angle-left pull-right"></i>
						</span>
					</a>
						<ul class="treeview-menu">
							<li><a href="city"><i class="fa fa-circle-o"></i>
									展示各国家城市列表</a></li>
							<li><a href="country"><i class="fa fa-circle-o"></i>
									展示中国的城市列表</a></li>

						</ul></li>

					<li><a href="fileupload"> <i class="fa fa-calendar"></i> <span>文件上传</span>

					</a></li>
					<li class="active"><a href="analysis"> <i
							class="fa fa-pie-chart"></i> <span>统计分析</span>
					</a></li>

				</ul>
			</section>
			<!-- /.sidebar -->
		</aside>

		<!-- Content Wrapper. Contains page content -->
		<div class="content-wrapper">
			<!-- Content Header (Page header) -->
			<section class="content-header">
				<h1>
					数据统计分析 <small>统计每个国家城市的数量</small>
				</h1>
				<ol class="breadcrumb">
					<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
					<li class="active">统计每个国家城市的数量</li>
				</ol>
			</section>

			<!-- Main content -->
			<section class="content">
				<!-- Info boxes -->
					<!-- Main row -->
					<div class="row">
						<!-- Left col -->
						<div class="col-md-12">
							<!-- TABLE: LATEST ORDERS -->
							<div class="box box-info">
								<div class="box-header with-border">
									<h3 class="box-title">柱状图</h3>

									<div class="box-tools pull-right">
										<button type="button" class="btn btn-box-tool"
											data-widget="collapse">
											<i class="fa fa-minus"></i>
										</button>
										<button type="button" class="btn btn-box-tool"
											data-widget="remove">
											<i class="fa fa-times"></i>
										</button>
									</div>
								</div>
								<!-- /.box-header -->
								<div class="box-body">
									<div class="chart">
						                <canvas id="barChart" style="height:260px"></canvas>
						            </div>
								</div>
								<!-- /.box-body -->
								<div class="box-footer clearfix"></div>
								<!-- /.box-footer -->
							</div>
							<!-- /.box -->
						</div>
						<!-- /.col -->
						
					</div>
					<div class="row">
					<div class="col-md-6">
							<!-- TABLE: LATEST ORDERS -->
							<div class="box box-info">
								<div class="box-header with-border">
									<h3 class="box-title">饼状图</h3>

									<div class="box-tools pull-right">
										<button type="button" class="btn btn-box-tool"
											data-widget="collapse">
											<i class="fa fa-minus"></i>
										</button>
										<button type="button" class="btn btn-box-tool"
											data-widget="remove">
											<i class="fa fa-times"></i>
										</button>
									</div>
								</div>
								<!-- /.box-header -->
								<div class="box-body">
									<div class="chart">
						                <canvas id="pieChart" style="height:260px"></canvas>
						            </div>
								</div>
								<!-- /.box-body -->
								<div class="box-footer clearfix"></div>
								<!-- /.box-footer -->
							</div>
							<!-- /.box -->
						</div>
						<!-- /.col -->
					
						<div class="col-md-6">
							<!-- TABLE: LATEST ORDERS -->
							<div class="box box-info">
								<div class="box-header with-border">
									<h3 class="box-title">曲线图</h3>

									<div class="box-tools pull-right">
										<button type="button" class="btn btn-box-tool"
											data-widget="collapse">
											<i class="fa fa-minus"></i>
										</button>
										<button type="button" class="btn btn-box-tool"
											data-widget="remove">
											<i class="fa fa-times"></i>
										</button>
									</div>
								</div>
								<!-- /.box-header -->
								<div class="box-body">
									<div class="chart">
						                <canvas id="lineChart" style="height:260px"></canvas>
						            </div>
								</div>
								<!-- /.box-body -->
								<div class="box-footer clearfix"></div>
								<!-- /.box-footer -->
							</div>
							<!-- /.box -->
					</div>
					</div>
			</section>
			<!-- /.content -->
		</div>
		<!-- /.content-wrapper -->

		<footer class="main-footer">
			<div class="pull-right hidden-xs">
				<b>Version</b> 2.4.18
			</div>
			<strong>Copyright &copy; 2014-2019 <a
				href="https://adminlte.io">AdminLTE</a>.
			</strong> All rights reserved.
		</footer>

		<!-- Control Sidebar -->
		<aside class="control-sidebar control-sidebar-dark">
			<!-- Create the tabs -->
			<ul class="nav nav-tabs nav-justified control-sidebar-tabs">
				<li><a href="#control-sidebar-home-tab" data-toggle="tab"><i
						class="fa fa-home"></i></a></li>
				<li><a href="#control-sidebar-settings-tab" data-toggle="tab"><i
						class="fa fa-gears"></i></a></li>
			</ul>
			<!-- Tab panes -->
			<div class="tab-content">
				<!-- Home tab content -->
				<div class="tab-pane" id="control-sidebar-home-tab">
					<h3 class="control-sidebar-heading">Recent Activity</h3>
					<ul class="control-sidebar-menu">
						<li><a href="javascript:void(0)"> <i
								class="menu-icon fa fa-birthday-cake bg-red"></i>

								<div class="menu-info">
									<h4 class="control-sidebar-subheading">Langdon's Birthday</h4>

									<p>Will be 23 on April 24th</p>
								</div>
						</a></li>
						<li><a href="javascript:void(0)"> <i
								class="menu-icon fa fa-user bg-yellow"></i>

								<div class="menu-info">
									<h4 class="control-sidebar-subheading">Frodo Updated His
										Profile</h4>

									<p>New phone +1(800)555-1234</p>
								</div>
						</a></li>
						<li><a href="javascript:void(0)"> <i
								class="menu-icon fa fa-envelope-o bg-light-blue"></i>

								<div class="menu-info">
									<h4 class="control-sidebar-subheading">Nora Joined Mailing
										List</h4>

									<p>nora@example.com</p>
								</div>
						</a></li>
						<li><a href="javascript:void(0)"> <i
								class="menu-icon fa fa-file-code-o bg-green"></i>

								<div class="menu-info">
									<h4 class="control-sidebar-subheading">Cron Job 254
										Executed</h4>

									<p>Execution time 5 seconds</p>
								</div>
						</a></li>
					</ul>
					<!-- /.control-sidebar-menu -->

					<h3 class="control-sidebar-heading">Tasks Progress</h3>
					<ul class="control-sidebar-menu">
						<li><a href="javascript:void(0)">
								<h4 class="control-sidebar-subheading">
									Custom Template Design <span
										class="label label-danger pull-right">70%</span>
								</h4>

								<div class="progress progress-xxs">
									<div class="progress-bar progress-bar-danger"
										style="width: 70%"></div>
								</div>
						</a></li>
						<li><a href="javascript:void(0)">
								<h4 class="control-sidebar-subheading">
									Update Resume <span class="label label-success pull-right">95%</span>
								</h4>

								<div class="progress progress-xxs">
									<div class="progress-bar progress-bar-success"
										style="width: 95%"></div>
								</div>
						</a></li>
						<li><a href="javascript:void(0)">
								<h4 class="control-sidebar-subheading">
									Laravel Integration <span
										class="label label-warning pull-right">50%</span>
								</h4>

								<div class="progress progress-xxs">
									<div class="progress-bar progress-bar-warning"
										style="width: 50%"></div>
								</div>
						</a></li>
						<li><a href="javascript:void(0)">
								<h4 class="control-sidebar-subheading">
									Back End Framework <span class="label label-primary pull-right">68%</span>
								</h4>

								<div class="progress progress-xxs">
									<div class="progress-bar progress-bar-primary"
										style="width: 68%"></div>
								</div>
						</a></li>
					</ul>
					<!-- /.control-sidebar-menu -->

				</div>
				<!-- /.tab-pane -->

				<!-- Settings tab content -->
				<div class="tab-pane" id="control-sidebar-settings-tab">
					<form method="post">
						<h3 class="control-sidebar-heading">General Settings</h3>

						<div class="form-group">
							<label class="control-sidebar-subheading"> Report panel
								usage <input type="checkbox" class="pull-right" checked>
							</label>

							<p>Some information about this general settings option</p>
						</div>
						<!-- /.form-group -->

						<div class="form-group">
							<label class="control-sidebar-subheading"> Allow mail
								redirect <input type="checkbox" class="pull-right" checked>
							</label>

							<p>Other sets of options are available</p>
						</div>
						<!-- /.form-group -->

						<div class="form-group">
							<label class="control-sidebar-subheading"> Expose author
								name in posts <input type="checkbox" class="pull-right" checked>
							</label>

							<p>Allow the user to show his name in blog posts</p>
						</div>
						<!-- /.form-group -->

						<h3 class="control-sidebar-heading">Chat Settings</h3>

						<div class="form-group">
							<label class="control-sidebar-subheading"> Show me as
								online <input type="checkbox" class="pull-right" checked>
							</label>
						</div>
						<!-- /.form-group -->

						<div class="form-group">
							<label class="control-sidebar-subheading"> Turn off
								notifications <input type="checkbox" class="pull-right">
							</label>
						</div>
						<!-- /.form-group -->

						<div class="form-group">
							<label class="control-sidebar-subheading"> Delete chat
								history <a href="javascript:void(0)" class="text-red pull-right"><i
									class="fa fa-trash-o"></i></a>
							</label>
						</div>
						<!-- /.form-group -->
					</form>
				</div>
				<!-- /.tab-pane -->
			</div>
		</aside>
		<!-- /.control-sidebar -->
		<!-- Add the sidebar's background. This div must be placed
       immediately after the control sidebar -->
		<div class="control-sidebar-bg"></div>

	</div>
	<!-- ./wrapper -->

	<!-- jQuery 3 -->
	<script src="bower_components/jquery/dist/jquery.min.js"></script>
	<!-- Bootstrap 3.3.7 -->
	<script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
	<!-- FastClick -->
	<script src="bower_components/fastclick/lib/fastclick.js"></script>
	<!-- AdminLTE App -->
	<script src="dist/js/adminlte.min.js"></script>
	<!-- Sparkline -->
	<script
		src="bower_components/jquery-sparkline/dist/jquery.sparkline.min.js"></script>
	<!-- jvectormap  -->
	<script src="plugins/jvectormap/jquery-jvectormap-1.2.2.min.js"></script>
	<script src="plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>
	<!-- bootstrap datepicker -->
	<script
		src="bower_components/bootstrap-datepicker/dist/js/bootstrap-datepicker.min.js"></script>
	<!-- SlimScroll -->
	<script
		src="bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
	<!-- ChartJS -->
	<script src="bower_components/chart.js/Chart.js"></script>
	<!-- bootgrid -->
	<script src="dist/js/jquery.bootgrid.min.js"></script>
	<!-- AdminLTE for demo purposes -->
	<script src="dist/js/demo.js"></script>
	<script>
		$(function() {
		    $.get("/currentuser",function(data){
        	  $(".username").text(data.msg);
    	    });

			var numbers = [];
			var countrys = [];
			// 获取数据
			$.get("cityanalysis", function(data) {
				for (var i = 0; i < data.length; i++) {
					numbers[i] = data[i].citynumber;
					countrys[i] = data[i].country;
				}
				var areaChartData = {
					labels : countrys,
					datasets : [
						{
							label : 'Digital Goods',
							fillColor : 'rgba(60,141,188,0.9)',
							strokeColor : 'rgba(60,141,188,0.8)',
							pointColor : '#3b8bba',
							pointStrokeColor : 'rgba(60,141,188,1)',
							pointHighlightFill : '#fff',
							pointHighlightStroke : 'rgba(60,141,188,1)',
							data : numbers
						}
					]
				}
				//-------------
				//- BAR CHART -
				//-------------
				var barChartCanvas = $('#barChart').get(0).getContext('2d')
				var barChart = new Chart(barChartCanvas)
				var barChartData = areaChartData
				barChartData.datasets[0].fillColor = '#20D5DB'
				barChartData.datasets[0].strokeColor = '#00a65a'
				barChartData.datasets[0].pointColor = '#00a65a'
				var barChartOptions = {
					//Boolean - Whether the scale should start at zero, or an order of magnitude down from the lowest value
					scaleBeginAtZero : true,
					//Boolean - Whether grid lines are shown across the chart
					scaleShowGridLines : true,
					//String - Colour of the grid lines
					scaleGridLineColor : 'rgba(0,0,0,.05)',
					//Number - Width of the grid lines
					scaleGridLineWidth : 1,
					//Boolean - Whether to show horizontal lines (except X axis)
					scaleShowHorizontalLines : true,
					//Boolean - Whether to show vertical lines (except Y axis)
					scaleShowVerticalLines : true,
					//Boolean - If there is a stroke on each bar
					barShowStroke : true,
					//Number - Pixel width of the bar stroke
					barStrokeWidth : 2,
					//Number - Spacing between each of the X value sets
					barValueSpacing : 5,
					//Number - Spacing between data sets within X values
					barDatasetSpacing : 1,
					//String - A legend template
					legendTemplate : '<ul class="<%=name.toLowerCase()%>-legend"><% for (var i=0; i<datasets.length; i++){%><li><span style="background-color:<%=datasets[i].fillColor%>"></span><%if(datasets[i].label){%><%=datasets[i].label%><%}%></li><%}%></ul>',
					//Boolean - whether to make the chart responsive
					responsive : true,
					maintainAspectRatio : true
				}
	
				barChartOptions.datasetFill = false
				barChart.Bar(barChartData, barChartOptions);
	
				// 饼图
				var pieChartCanvas = $('#pieChart').get(0).getContext('2d')
				var pieChart = new Chart(pieChartCanvas);
				var PieData = [];
				for (var i = 0; i < 10; i++) {
					PieData[i] = {};
					PieData[i].value = numbers[i];
					PieData[i].label = countrys[i];
				}
				var pieOptions = {
					//Boolean - Whether we should show a stroke on each segment
					segmentShowStroke : true,
					//String - The colour of each segment stroke
					segmentStrokeColor : '#fff',
					//Number - The width of each segment stroke
					segmentStrokeWidth : 2,
					//Number - The percentage of the chart that we cut out of the middle
					percentageInnerCutout : 50, // This is 0 for Pie charts
					//Number - Amount of animation steps
					animationSteps : 100,
					//String - Animation easing effect
					animationEasing : 'easeOutBounce',
					//Boolean - Whether we animate the rotation of the Doughnut
					animateRotate : true,
					//Boolean - Whether we animate scaling the Doughnut from the centre
					animateScale : false,
					//Boolean - whether to make the chart responsive to window resizing
					responsive : true,
					// Boolean - whether to maintain the starting aspect ratio or not when responsive, if set to false, will take up entire container
					maintainAspectRatio : true,
					//String - A legend template
					legendTemplate : '<ul class="<%=name.toLowerCase()%>-legend"><% for (var i=0; i<segments.length; i++){%><li><span style="background-color:<%=segments[i].fillColor%>"></span><%if(segments[i].label){%><%=segments[i].label%><%}%></li><%}%></ul>'
				}
				//Create pie or douhnut chart
				// You can switch between pie and douhnut using the method below.
				pieChart.Doughnut(PieData, pieOptions);
				var areaChartOptions = {
					//Boolean - If we should show the scale at all
					showScale : true,
					//Boolean - Whether grid lines are shown across the chart
					scaleShowGridLines : false,
					//String - Colour of the grid lines
					scaleGridLineColor : 'rgba(0,0,0,.05)',
					//Number - Width of the grid lines
					scaleGridLineWidth : 1,
					//Boolean - Whether to show horizontal lines (except X axis)
					scaleShowHorizontalLines : true,
					//Boolean - Whether to show vertical lines (except Y axis)
					scaleShowVerticalLines : true,
					//Boolean - Whether the line is curved between points
					bezierCurve : true,
					//Number - Tension of the bezier curve between points
					bezierCurveTension : 0.3,
					//Boolean - Whether to show a dot for each point
					pointDot : false,
					//Number - Radius of each point dot in pixels
					pointDotRadius : 4,
					//Number - Pixel width of point dot stroke
					pointDotStrokeWidth : 1,
					//Number - amount extra to add to the radius to cater for hit detection outside the drawn point
					pointHitDetectionRadius : 20,
					//Boolean - Whether to show a stroke for datasets
					datasetStroke : true,
					//Number - Pixel width of dataset stroke
					datasetStrokeWidth : 2,
					//Boolean - Whether to fill the dataset with a color
					datasetFill : true,
					//String - A legend template
					legendTemplate : '<ul class="<%=name.toLowerCase()%>-legend"><% for (var i=0; i<datasets.length; i++){%><li><span style="background-color:<%=datasets[i].lineColor%>"></span><%if(datasets[i].label){%><%=datasets[i].label%><%}%></li><%}%></ul>',
					//Boolean - whether to maintain the starting aspect ratio or not when responsive, if set to false, will take up entire container
					maintainAspectRatio : true,
					//Boolean - whether to make the chart responsive to window resizing
					responsive : true
				}
				//- LINE CHART -
				//--------------
				var lineChartCanvas = $('#lineChart').get(0).getContext('2d')
				var lineChart = new Chart(lineChartCanvas)
				var lineChartOptions = areaChartOptions
				lineChartOptions.datasetFill = false
				lineChart.Line(areaChartData, lineChartOptions)
	
			});
	
	
	
	
		});
	</script>

</body>
</html>
